🕷️️ Job Radar • SCRAPING

freelancer.com 🟠 2026-05-02

🔹 [Target] Excel-Claude Integration [Method] Python Scripting [UI/UX] None [Stack] Python 3.x with requests, pandas, openpyxl [Security] Basic Error Logging [Format] Strict JSON Parsing
👤 Client: 🇮🇳 Ahmedabad, India Member since 2026-04-30
💰 Price: $75 Average bid
🚩 Problem: Integrate company names from an Excel sheet into Claude AI API for contact discovery and export results back to Excel.
📦 Existing: Not specified

Specifications:

[Target] Define a Python script that reads company names from an Excel file, queries Claude AI through its API, processes the JSON response, and writes the data back to an Excel sheet.
[Method] Use Python 3.x with requests for API calls, pandas for handling Excel files, and openpyxl for writing results. Implement error logging and rate limiting to ensure reliability.
[UI/UX] No UI automation; focus on backend processing.
[Stack] Python 3.x, requests, pandas, openpyxl
[Security] Log errors and implement back-off delays to avoid triggering rate limits.
[Format] Parse JSON responses into a structured Excel format with separate rows for each contact.

Workflow:

1. Read company names from an Excel sheet using pandas.
2. For each company name, make API calls to Claude AI through requests library.
3. Parse the JSON response and extract relevant fields (website, email, phone, title).
4. Write the extracted data into a new Excel sheet with one row per contact, repeating parent company data as necessary.
5. Implement error handling and logging for failed API calls or parsing issues.
6. Add back-off delays to handle rate limits gracefully.